[dbo].[UniformTypeRef]

Property	Value
Created	10:31:42 AM Tuesday, March 02, 2010
Last Modified	4:01:58 AM Thursday, March 15, 2012

Property

Value

Created

10:31:42 AM Tuesday, March 02, 2010

Last Modified

4:01:58 AM Thursday, March 15, 2012

Name	Data Type	Max Length (Bytes)
UniformType	nvarchar(100)	200
UniformTypeDesc	nvarchar(100)	200
SubjectNameField	nvarchar(50)	100
SubjectIconPath	nvarchar(255)	510

Name

Data Type

Max Length (Bytes)

Allow Nulls

UniformType

nvarchar(100)

200

UniformTypeDesc

nvarchar(100)

200

SubjectNameField

nvarchar(50)

100

SubjectIconPath

nvarchar(255)

510

	Name	Columns	Unique
	PK_UniformTypeRef	UniformType
	AK_UniformTypeRef_UniformTypeDesc	UniformTypeDesc

Name

Columns

Unique

PK_UniformTypeRef

UniformType

AK_UniformTypeRef_UniformTypeDesc

UniformTypeDesc

SQL Script

CREATE TABLE [dbo].[UniformTypeRef]
(
[UniformType] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UniformTypeDesc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SubjectNameField] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubjectIconPath] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UniformTypeRef] ADD CONSTRAINT [PK_UniformTypeRef] PRIMARY KEY CLUSTERED ([UniformType]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UniformTypeRef] ADD CONSTRAINT [AK_UniformTypeRef_UniformTypeDesc] UNIQUE NONCLUSTERED ([UniformTypeDesc]) ON [PRIMARY]
GO